Introduction to Data Warehouses

Back to Home

01. Course Introduction
02. Lesson Introduction
03. Data Warehouse: Business Perspective
04. Operational vs. Analytical Processes
05. Data Warehouse: Technical Perspective
06. Dimensional Modeling
07. ETL Demo: Step 1 & 2
08. Exercise 1: Step 1 & 2
09. ETL Demo: Step 3
10. Exercise 1: Step 3
11. ETL Demo: Step 4
12. Exercise 1: Step 4
13. ETL Demo: Step 5
14. Exercise 1: Step 5
15. ETL Demo: Step 6
16. Exercise 1: Step 6
17. Exercise Solution 1: 3NF to Star Schema
18. DWH Architecture: Kimball's Bus Architecture
19. DWH Architecture: Independent Data Marts
20. DWH Architecture: CIF
21. DWH Architecture: Hybrid Bus & CIF
22. OLAP Cubes
23. OLAP Cubes: Roll-Up and Drill Down
24. OLAP Cubes: Slice and Dice
25. OLAP Cubes: Query Optimization
26. OLAP Cubes Demo: Slicing & Dicing
27. Exercise 2: Slicing & Dicing
28. OLAP Cubes Demo: Roll-Up
29. Exercise 2: Roll-Up & Drill Down
30. OLAP Cubes Demo: Grouping Sets
31. Exercise 2: Grouping Sets
32. OLAP Cubes Demo: CUBE
33. Exercise 2: CUBE
34. Data Warehouse Technologies
35. Demo: Column format in ROLAP
36. Exercise 3: Column format in ROLAP

Back to Home

19. DWH Architecture: Independent Data Marts

L01-05-Part 2 Architecture- Independent Data Marts

True or False:

Independent Data Marts have ETL processes that are designed by specific business departments to meet their analytical needs.

True

False

SOLUTION:

True

**True or False: **

Independent Data Marts are highly encouraged to help business departments meet their analytic needs.

True

False

SOLUTION:

False

Learn Udacity: click here to learn more :)